Monthly Promotions

Howard is planning single-month and multi-month promotions for QuickStove products. He would like a worksheet created that will allow him to copy in the previous month’s data and use it to determine how much promotional material he will need.

There are two criteria that must be satisfied for a promo to be sent to customers. First, the customer must have purchased more than one of any QuickStove product. Second, the customer must order from one of the current promo states.

For the first promotion, Howard is planning a single-month promotion for customers in Colorado and Nevada and a multi-month promotion in Utah and Oregon.

Use Boolean functions to help Howard make single and multi-month promotion decisions.

Work with Boolean Functions